<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@page import="com.jdbc.Jdbc"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="com.project.bean.*"%>
<%@page import="java.util.ArrayList"%>
<%@page import="java.util.List"%>
<%-- <%@page import="java.sql.SQLException" %> --%>
<%
	
	String role = (String) request.getSession().getAttribute("role");
	String username = (String) request.getSession().getAttribute("username");
	String find = null;
	//只有将这个学生对应录入信息的老师才能给他管理
	if (!role.equals("管理员")) {

		request.getRequestDispatcher("showAuthority.jsp").forward(request, response);
		return;
	}

	if (role.equals("管理员")) {
		find = "select* from contract";
	} else {
		find = "select* from contract where username='" + username + "'";
	}

	Jdbc j = new Jdbc();

	String classstate;//用于记录排班的情况

	ResultSet rs;

	List<Contract> list = new ArrayList<>();

	j.Jdbc_Q2(find);
	rs = j.rs;
	while (rs.next()) {
		Contract c = new Contract();
		c.setContractid(rs.getString("contractid"));
		c.setId(rs.getString("id"));
		c.setChinesename(rs.getString("chinesename"));
		c.setEnglishname(rs.getString("englishname"));
		c.setTotalclass(rs.getString("totalclass"));
		c.setRestclass(rs.getString("restclass"));
		list.add(c);
	}
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>

<head>
<meta charset="utf-8">
<title>排班</title>
<meta name="renderer" content="webkit">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport"
	content="width=device-width, initial-scale=1, maximum-scale=1">
<meta name="apple-mobile-web-app-status-bar-style" content="black">
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="format-detection" content="telephone=no">
<link rel="stylesheet" href="./css/x-admin.css" media="all">
</head>
<body>
	<div class="x-nav">
		<span class="layui-breadcrumb"> <a><cite>首页</cite></a> <a><cite>排课管理</cite></a>
		</span> <a class="layui-btn layui-btn-small"
			style="line-height: 1.6em; margin-top: 3px; float: right"
			href="javascript:location.replace(location.href);" title="刷新"><i
			class="layui-icon" style="line-height: 30px">ဂ</i></a>
	</div>
	<div class="x-body">
		<form class="layui-form x-center" action="" style="width: 500px">
			<div class="layui-form-pane" style="margin-top: 15px;">
				<div class="layui-form-item">
					<div class="layui-input-inline" style="width: 400px"></div>
					<div class="layui-input-inline" style="width: 80px"></div>
				</div>
			</div>
		</form>
		<!--  <xblock>
            <button class="layui-btn" onclick="user_management_add('添加数据','contract_add.jsp','600','500')"><i class="layui-icon">&#xe608;</i>添加</button>
            <button class="layui-btn" onclick=""><form action="contractOutput" method="post"><input type="submit"  class="layui-btn"  value="签约信息导出"></form></button>
             <button class="layui-btn" onclick="user_management_add('数据导入','contractInputDB.jsp','600','500')"><i class="layui-icon"></i>Excel导入数据库</button>
             <button class="layui-btn" onclick=""><form action="contractModel" method="post"><input type="submit"  class="layui-btn"  value="模板下载"></form></button>
           
            <span class="x-right" style="line-height:25px"></span></xblock> -->
            <form action="searchstu_add_classbyperson" method="post"><input type="text" name="chinesename"  lay-verify="pass"
						class="" value="输入查询的学生姓名">
						<input type="submit" value="查询"></form>
		<table class="layui-table">
			<thead>
				<tr>
					<th>合同ID</th>
					<th>ID</th>
					<th>学员中文名</th>
					<th>学员英文名</th>
					<th>总课时</th>
					<th>剩余课时</th>

					<th>排班情况</th>
					<th>操作</th>
				</tr>
			</thead>
			<tbody>
				<%
					for (Contract c : list) {

						//每次遍历的时候都要查询一下这个对象的学生ID是否在STU-CLASS存在
						String find_stu = c.getId();
						Jdbc j_stu = new Jdbc();
						String find1 = "select classname from stu_class where stuid='" + find_stu + "'";

						j_stu.Jdbc_Q2(find1);
						j_stu.rs.last();//将光标移动得到最后
						j_stu.rs.getRow();//获得结果集的个数，如果为0代表没有记录

						if (j_stu.rs.getRow() == 0) {
							classstate = "未排班";
						} else {
							String rs1 = "已排";
							classstate = rs1;//将数据库查到的结果 赋予排班变量
						}
				%>
				<tr>

					<td><%=c.getContractid()%></td>
					<td><%=c.getId()%></td>
					<td><%=c.getChinesename()%></td>
					<td><%=c.getEnglishname()%></td>
					<td><%=c.getTotalclass()%></td>
					<td><%=c.getRestclass()%></td>
					<!-- 显示排班情况，这个情况要从STU-CLASS表中去查找，若查到代表已经排班排好，否则，显示未排班 -->
					<td><%=classstate%></td>
					<td class="td-manage"><a title="编辑" href="javascript:;"
						onclick="user_management_edit('排班','stu_add_class.jsp?stuid=<%=c.getId()%>&stuname=<%=c.getChinesename()%>','4','','510')"
						class="ml-5" style="text-decoration: none"> <i
							class="layui-icon">&#xe642;</i>
					</a> <a title="具体情况" style="text-decoration: none"
						onclick="user_management_password('显示选班','show_stuchooseclass.jsp?stuid=<%=c.getId()%>','4','','510')"
						href="javascript:;" title=""> <i class="layui-icon">&#xe631;</i>
					</a> <%-- <a title="删除" href="javascript:;" onclick="user_management_delete('删除用户','contract_delete.jsp?contractid=<%=c.getContractid() %>','10001','600','400')"
                            style="text-decoration:none"> 
                                <i class="layui-icon">&#xe640;</i>
                            </a>--%></td>
				</tr>


			</tbody>
			<%
				}
				rs.close();
			%>
		</table>

		<!-- <div id="page"></div> -->
	</div>
	<br />
	<br />
	<br />
	<script src="./lib/layui/layui.js" charset="utf-8"></script>
	<script src="./js/x-layui.js" charset="utf-8"></script>
	<script>
		layui.use([ 'laydate', 'element', 'laypage', 'layer' ], function() {
			$ = layui.jquery;//jquery
			laydate = layui.laydate;//日期插件
			lement = layui.element();//面包导航
			laypage = layui.laypage;//分页
			layer = layui.layer;//弹出层

			//以上模块根据需要引入

			laypage({
				cont : 'page',
				pages : 100,
				first : 1,
				last : 100,
				prev : '<em><</em>',
				next : '<em>></em>'
			});

			var start = {
				min : laydate.now(),
				max : '2099-06-16 23:59:59',
				istoday : false,
				choose : function(datas) {
					end.min = datas; //开始日选好后，重置结束日的最小日期
					end.start = datas //将结束日的初始值设定为开始日
				}
			};

			var end = {
				min : laydate.now(),
				max : '2099-06-16 23:59:59',
				istoday : false,
				choose : function(datas) {
					start.max = datas; //结束日选好后，重置开始日的最大日期
				}
			};

		});

		//批量删除提交
		function delAll() {
			layer.confirm('确认要删除吗？', function(index) {
				//捉到所有被选中的，发异步进行删除
				layer.msg('删除成功', {
					icon : 1
				});
			});
		}
		/*用户-添加*/
		function user_management_add(title, url, w, h) {
			x_admin_show(title, url, w, h);
		}
		/*用户-查看*/
		function user_management_show(title, url, id, w, h) {
			x_admin_show(title, url, w, h);
		}

		/*用户-停用*/
		function member_stop(obj, id) {
			layer
					.confirm(
							'确认要停用吗？',
							function(index) {
								//发异步把用户状态进行更改
								$(obj)
										.parents("tr")
										.find(".td-manage")
										.prepend(
												'<a style="text-decoration:none" onClick="member_start(this,id)" href="javascript:;" title="启用"><i class="layui-icon">&#xe62f;</i></a>');
								$(obj)
										.parents("tr")
										.find(".td-status")
										.html(
												'<span class="layui-btn layui-btn-disabled layui-btn-mini">已停用</span>');
								$(obj).remove();
								layer.msg('已停用!', {
									icon : 5,
									time : 1000
								});
							});
		}

		/*用户-启用*/
		function member_start(obj, id) {
			layer
					.confirm(
							'确认要启用吗？',
							function(index) {
								//发异步把用户状态进行更改
								$(obj)
										.parents("tr")
										.find(".td-manage")
										.prepend(
												'<a style="text-decoration:none" onClick="member_stop(this,id)" href="javascript:;" title="停用"><i class="layui-icon">&#xe601;</i></a>');
								$(obj)
										.parents("tr")
										.find(".td-status")
										.html(
												'<span class="layui-btn layui-btn-normal layui-btn-mini">已启用</span>');
								$(obj).remove();
								layer.msg('已启用!', {
									icon : 6,
									time : 1000
								});
							});
		}
		// 用户-编辑
		function user_management_edit(title, url, id, w, h) {
			x_admin_show(title, url, w, h);
		}
		/*密码-修改*/
		function user_management_password(title, url, id, w, h) {
			x_admin_show(title, url, w, h);
		}
		//删除用户
		function user_management_delete(title, url, id, w, h) {
			x_admin_show(title, url, w, h);
		}
		/*用户-删除*/
		function member_del(obj, id) {
			layer.confirm('确认要删除吗？', function(index) {
				//发异步删除数据
				$(obj).parents("tr").remove();
				layer.msg('已删除!', {
					icon : 1,
					time : 1000
				});
			});
		}
	</script>
	<script>
		var _hmt = _hmt || [];
		(function() {
			var hm = document.createElement("script");
			var s = document.getElementsByTagName("script")[0];
			s.parentNode.insertBefore(hm, s);
		})();
	</script>
</body>
</html>
